CompositeHealthSegment

Entity Definition

Logical Name : CompositeHealthSegment
Physical Name : CO_HLTH_SGMT

An exploratory entity used to capture dietary, disability and may be extended to capture other health-related information for customer segmentation purposes. Note this is exploratory only because there are legal and regulatory privacy rules that limit the kinds of health information that can be collected (e.g. in the USA HIPPA). Retailers should not implement this without a careful review by their attorneys.

Data Definition

Attribute	Description	Physical Name	Domain	Data Type	Foreign Key Table
HealthSegmentID (PK)	Token ID for a Health-oriented customer composite segment	ID_HLTH_SGMT	Identity	integer
DietaryHabitTypeCode (FK)	Code that identifies a particular dietary habit.	CD_DTRY_HBT_TYP	Code	varchar(20)	DietaryHabitType(LU_DTRY_HBT)
DisabilityImpairmentTypeCode (FK)	Identifies a retailer specified disability or impairment.	CD_DSBLTY_IMPRMNT_TYP	Code	varchar(20)	DisabilityImpairmentType(LU_DSBLTY_IMPRMNT)

Relationships

Parent Entity	Verb Phrase	Child Entity
DisabilityImpairmentType	characterizes	CompositeHealthSegment
DietaryHabitType	characterizes	CompositeHealthSegment
CompositeHealthSegment	characterizes	KeyIndividualCustomerCompositeSegment

Logical Views containing CompositeHealthSegment

Logical View
Logical 07030 - Customer Segment Independent Characteristics